package cn.wolfcode.wms.util;

import java.util.HashMap;
import java.util.LinkedHashMap;
import java.util.Map;

public abstract class Dictonary {
    //将需要查询的列设置为常量,显示到页面上
    public static final Map<String,String>ORDER_MAP = new LinkedHashMap<>();
    public static final Map<String,String>SALE_MAP = new LinkedHashMap<>();
    static {
        ORDER_MAP.put("e.name","订货员");
        ORDER_MAP.put("p.name","商品名称");
        ORDER_MAP.put("p.brand_name","商品品牌");
        ORDER_MAP.put("s.name","供应商");
        ORDER_MAP.put("DATE_FORMAT(ob.vdate,'%Y.%m')","订货月份");
        ORDER_MAP.put("DATE_FORMAT(ob.vdate,'%Y.%m.%d')","订货日期");

        SALE_MAP.put("e.name","销售员");
        SALE_MAP.put("p.name","商品名称");
        SALE_MAP.put("p.brand_name","商品品牌");
        SALE_MAP.put("c.name","客户");
        SALE_MAP.put("DATE_FORMAT(sale.vdate,'%Y.%m')","订货月份");
        SALE_MAP.put("DATE_FORMAT(sale.vdate,'%Y.%m.%d')","订货日期");

    }
}
